Labels:hakham | sky OCR: DATABASES 649 How does OR differ from AND? Two variations of the OR operator exist One variation, the inclusive OR designates records that meet one of the criteria or both. The other variation, called the exclusive OR, designates records that meet one criterion or the other, but not both SQL uses the inclusive OR A query such SEL ECT AlbumTitle FROM Albums WHERE ArtistName Jefferson Airplane OR DiscountPrice 10.00 produces all the Jefferson Airplane albums, regardless of price It also pro duces any albums that are less than $10.00 regardless of the artist. You can combine AND and OR clauses to formulate complex queries For example Jefferson Airplane became Jefferson Starship in 1974 p,nok like list of Jefferson Airplane or Jefferson Starship albums for less than $10.00 you can use query li ...
